(…)
with the appropriate connection details for both the PostgreSQL and BigQuery instances. More details on adding PEERs are available here.
sql
mode.
To perform CDC via AVRO mode, you must set the following:
WITH
clause captures if you wanted to include initial snapshot as a part of the MIRROR. If you don’t include that WITH
, peerdb assumes that you don’t want to perform an initial snapshot. If just reads the slot and replays the changes to the target.
PeerDB also supports replicating TOAST columns very efficiently. Unlike most CDC tools, you don’t need to set up REPLICA IDENTITY FULL for replicating TOAST columns. This PR captures the infrastructural optimizations that PeerDB takes to support TOAST columns.
localhost:8085
to get full visibility into the different jobs and steps that PeerDB is taking under the covers to manage the MIRROR.